#pragma once
#include <string>
#include <cstddef> 
#include <odb/core.hxx>

namespace suye
{
#pragma db object table("relation")
class Relation {
public:
    Relation() {}
    Relation(const std::string& uid, const std::string& pid) 
        : _user_id(uid), _peer_id(pid) {}

    ~Relation() {}

    std::string user_id() const { return _user_id; }
    void user_id(const std::string& val) { _user_id = val; }

    std::string peer_id() const { return _peer_id; }
    void peer_id(const std::string& val) { _peer_id = val; }

private:
    friend class odb::access;
    #pragma db id auto
    unsigned long _id;
    #pragma db type("varchar(64)") index 
    std::string _user_id;
    #pragma db type("varchar(64)")
    std::string _peer_id;
};
}

// odb -d mysql --std c++11 --generate-query --generate-schema --profile boost/date-time relation.hxx







